SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402584 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402584 [ RunTime:0.001633s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (205658,759147,332496,392559,491703,28170,135101,519984,934664,901321,227818,705218,746834,857563,561622,221211,897880,197803,195741,392143,398978,708768,897264,788673,721165,639435,590795,411185,54892,857076,223669,751168,288255,54297,701949,340323,961948,771122,874779,697746,660774,215133,582156,812973,939488,292045,50258,324847,663980,788647,722871,305006,999503,633499,142272,1041684,165503,97921,425737,608697) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402584 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002178s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402584 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000776s ]