SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501167 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501167 [ RunTime:0.002033s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (502037,982612,611204,712785,9933,1044923,595184,30734,589495,178811,504043,278112,444547,531904,129295,131086,992665,92908,911871,108128,975532,497952,514149,434427,269367,1032145,248561,861814,739187,455931,795973,538095,577401,899371,1003834,385085,847462,767804,546212,900255,154124,604473,13650,573492,292975,581369,213952,234762,706461,886414,740575,728503,1007220,223711,906581,660094,933275,562078,581256,242246) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501167 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501167 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]