SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402008 LIMIT 1 [ RunTime:0.002301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402008 [ RunTime:0.005952s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (236323,29563,205960,484145,268728,1014803,18854,283897,446888,65619,925831,135100,48015,83854,318651,308436,681303,907748,495036,410755,693155,500026,921217,689654,184576,706208,188523,590136,730828,731359,635177,997462,847931,233496,15076,655796,1025343,882994,335033,662068,559830,490756,77380,135595,418365,566583,554049,139095,392837,941648,76743,579671,55933,751124,569336,47967,364865,444325,197834,471511) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002078s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402008 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000954s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402008 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]