SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042398 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042398 [ RunTime:0.001562s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (100661,737692,850072,558177,277966,842168,1047367,842946,448401,897959,472626,3245,59096,384996,748535,935915,456595,440436,260536,324459,652239,187890,373797,563696,336205,531674,21301,499222,326964,898064,935908,588665,51985,553702,278601,27816,128146,350302,190765,561532,662052,1029507,1041610,360621,1001240,723853,766771,848861,158402,207372,77353,438691,517076,557220,127543,433479,430767,851069,1046090,914799) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042398 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042398 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]