SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 317620 LIMIT 1 [ RunTime:0.000514s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 317620 [ RunTime:0.001603s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (714084,1018672,71294,937736,204559,711631,577484,769695,318738,19321,718085,286810,602556,383467,460638,843699,943932,315906,956630,142871,128479,862986,77209,331366,520902,357622,1042673,263201,103706,68510,924093,505487,836711,733234,923831,472416,383956,498974,85127,213498,821464,682261,866991,218511,895395,11301,867048,463421,462773,85410,402743,432477,270400,541139,241962,404213,571499,53769,135948,531408) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 317620 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 317620 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]