SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002768s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404808 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404808 [ RunTime:0.001545s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (287494,155130,479386,302890,154728,193828,738015,772244,50316,138985,866120,513272,54153,745140,124655,593689,489017,368998,854052,121813,311014,579714,666725,619438,1048508,590163,119375,702794,696203,837967,314613,27126,463820,885864,925825,429693,142073,292957,704951,949979,436401,174394,36857,178806,833223,894434,1001782,618552,878739,936596,351813,766269,117600,55490,550707,772537,382790,1029055,809998,662038) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404808 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404808 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]