SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 318410 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 318410 [ RunTime:0.001706s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (958352,805549,199835,12666,356051,644904,252929,914578,1005623,473799,365519,155638,446580,432912,328508,524269,678171,51413,295592,508517,207950,275482,245291,346221,276692,520607,649990,24712,1038580,1001558,240728,621144,828337,934979,957994,671176,333777,387931,954652,581835,963612,996883,931671,614096,78786,919196,725992,371318,292505,144195,191054,229517,498266,112949,193226,658842,1039999,135257,437944,783976) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 318410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 318410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000642s ]