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` = 404612 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404612 [ RunTime:0.002364s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (221979,791566,1006775,351076,961628,170666,747304,276354,688016,303474,788885,18515,347115,671624,828843,246523,955544,799878,293272,652787,362978,994332,449348,1015397,103406,651407,815149,101241,263479,585637,126407,35182,985436,59280,779270,942247,238461,24087,240714,652156,920502,121201,727265,830506,829707,216302,416295,91917,634843,887475,567542,892059,860212,548006,495037,1008256,545825,935824,1021018,466816) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404612 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404612 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000637s ]