SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540892 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540892 [ RunTime:0.002339s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (265898,151620,522905,181512,538792,829169,643892,495736,267835,148683,974393,816987,354007,466028,352221,98531,259939,830084,191880,1009354,564150,281114,584808,346370,1034336,410713,935682,908187,930242,482310,353262,408249,253938,818196,580224,1040430,339852,522571,408545,37553,567669,433762,75421,327560,218189,426095,382377,145318,948146,404452,833651,9753,311437,793397,174815,653832,520243,330348,841908,682631) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540892 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540892 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001059s ]