SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415028 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415028 [ RunTime:0.001625s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (938581,586412,584055,157468,798458,545842,122111,116927,801795,358269,347579,1027075,411035,154084,327223,432922,256291,373809,798959,651441,851704,666627,529616,77983,1021509,4198,290903,417155,932174,249414,405577,674942,687999,176451,709610,319462,84764,183358,629229,836334,267928,439720,1042280,1003675,905436,964308,179745,882024,498889,617140,691702,834526,480279,961372,696119,255767,238929,96982,231310,683115) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000641s ]