SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 163512 LIMIT 1 [ RunTime:0.000510s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 163512 [ RunTime:0.003693s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (810155,997327,150698,600015,580974,1001860,664373,658849,1000607,992685,275135,580167,757791,905691,12774,145660,287270,540438,362448,331722,735879,675140,813058,611124,862019,686557,104110,823233,414290,258354,484038,131780,358208,186677,881552,273487,45299,962497,919195,458740,721589,117690,335920,340966,563893,263828,829997,973639,64103,927246,1024500,28128,162871,444698,467228,109048,107818,758313,931398,414833) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 163512 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000522s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 163512 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000740s ]