SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 806715 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 806715 [ RunTime:0.002139s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (614780,488484,743295,979978,15226,11879,144395,394453,594162,80272,909683,904878,835963,481308,752259,738384,494466,611383,160503,921153,559686,1023621,649056,367331,635100,562573,341675,247456,339889,80657,199201,802939,543588,447589,692897,229929,398534,556850,177905,705958,884849,928109,977699,140949,959511,725207,988542,66152,631210,86124,262732,959883,263364,479638,434813,74847,126121,964995,279316,254758) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001801s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 806715 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 806715 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000471s ]