SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 530421 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 530421 [ RunTime:0.001697s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (744250,510356,342743,680655,1025179,963404,727181,500758,206328,104472,783342,58791,911475,486842,81067,763510,147652,628032,835655,26652,553075,632136,849761,1028999,305664,610575,700229,1018318,860064,511862,939908,469122,263240,414127,766551,349704,181542,853047,1033449,118379,46156,372796,842864,769760,515657,13190,769105,197465,722100,269270,719454,309250,811007,733251,251187,924901,214407,928496,277207,512091) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 530421 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 530421 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]