SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001432s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 576683 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 576683 [ RunTime:0.002406s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (709429,754180,457306,598070,878202,842617,50740,695708,606494,456593,46742,112536,315972,240921,934601,918479,299376,142892,848651,23366,23224,184876,59093,679654,644682,313480,803295,933796,107886,876341,299744,219428,1016704,410183,411580,962927,210399,837133,482583,317192,15919,149545,48100,637105,1046815,635364,587642,751624,819963,255697,1040375,324032,708118,384103,117562,645782,989293,566899,868060,321860) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002831s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 576683 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 576683 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000622s ]