SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501419 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501419 [ RunTime:0.001895s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (61733,650037,276094,386832,651207,422329,735280,1000996,789956,259912,120688,516570,972125,294193,226658,169653,229667,194438,200648,137607,854509,219763,960814,899211,994399,743226,790279,554972,994271,537006,876856,260201,712956,375022,685191,66259,600839,670113,1005334,453104,244136,662246,286863,742975,458194,10860,132896,755611,984119,38185,22328,744868,714898,624751,683356,931536,313744,178128,41078,180194) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501419 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501419 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]