SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001300s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 392881 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 392881 [ RunTime:0.004862s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (344399,459997,418781,851397,6036,993852,641961,75817,790765,1046719,942868,141297,780184,589742,373706,407734,843098,937064,708411,504484,420535,360452,1015621,513851,374275,216215,157310,996315,257671,571588,971961,352074,411548,841465,471153,19952,420820,556757,576344,384502,671167,858544,298246,289736,978925,999192,333375,896537,825850,38756,196563,509916,139667,672786,498424,55964,212828,678624,68215,800465) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004702s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 392881 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000650s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 392881 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002136s ]