SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001431s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 496909 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 496909 [ RunTime:0.001695s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (791528,931765,854419,870622,394007,832815,468899,848788,563367,150663,583185,67534,246334,578584,335329,255023,872112,373993,84358,973936,289606,596494,245462,953300,83262,867015,692030,472611,460598,329591,268445,685688,241802,178361,813883,408298,364817,220244,858575,1034056,995610,704642,319526,321482,105879,264798,550671,593890,655579,114891,955337,770695,519424,854766,652021,240140,72693,517832,561156,238459) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 496909 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 496909 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000673s ]