SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 346588 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 346588 [ RunTime:0.002362s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (562552,108013,400634,1048161,715644,277908,179738,184761,407981,985239,407780,740078,13202,934645,1034786,88497,101491,201868,791670,288429,559532,966770,884197,287806,248009,203401,622603,478466,411643,267669,305097,1045544,896256,262519,217827,714493,607353,825677,638046,1013398,687195,482103,324347,393058,745898,760191,397150,401102,256539,405232,745487,216767,90991,177629,542725,1023562,652369,67449,493929,974197) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 346588 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 346588 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]