SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501753 LIMIT 1 [ RunTime:0.000499s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501753 [ RunTime:0.001796s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (682459,1041834,189725,900927,116337,1022193,150706,590592,746449,108282,464503,257484,326471,508933,63738,163506,140517,948975,354628,531653,454007,157065,95073,511655,335661,28049,650936,909878,465329,794829,777560,304272,471204,960911,358503,151821,163972,61824,1045856,953638,132787,847425,67665,72122,586433,757035,356058,1012091,839757,520043,531710,981027,47956,312365,416097,151332,552159,940396,733460,570803) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501753 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000502s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501753 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000785s ]