SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514838 LIMIT 1 [ RunTime:0.000457s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514838 [ RunTime:0.006124s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (143935,908289,929812,310170,899180,564523,605072,784077,457411,659327,309483,142918,342169,130935,829580,837455,820105,388123,96965,745062,281814,242325,635457,95760,992434,873422,413672,761500,842414,671919,932495,58948,617875,665774,855506,946331,746864,194734,980707,547818,697573,5828,75534,690432,561147,285972,955079,576465,87923,781032,154782,274254,771456,831975,635306,835994,716986,979092,181834,610562) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001547s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514838 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000883s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514838 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]