SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201064 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201064 [ RunTime:0.001867s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1043293,154185,791119,346805,508903,982638,77419,864291,291832,786013,660973,929106,258219,766434,961713,591019,277689,182603,710267,375872,658525,954038,118276,226243,188765,959245,193903,448289,263626,444820,395234,89180,538172,737955,935729,986797,603799,364965,252278,556793,821328,367512,143811,133785,667588,745266,586070,1034548,831747,1048364,155794,150876,677685,461134,257655,226920,603679,29051,104150,888280) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201064 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201064 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]