SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419096 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419096 [ RunTime:0.002371s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (36031,1032298,681407,529758,140437,62598,878505,635040,391818,596044,898069,508025,326002,485084,431451,665659,373230,381348,133690,68183,300652,67068,38835,532380,735396,315546,801752,687065,846366,816805,498438,880096,253233,970330,708661,114076,942506,877153,943292,80286,255620,803068,220360,689062,255562,1037440,685192,25982,1005874,598635,615180,918279,701315,1016547,488377,908930,661544,710516,152112,662257) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419096 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419096 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]