SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001353s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 473219 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 473219 [ RunTime:0.001988s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1027116,341684,824655,1022150,178485,1015934,691382,114531,251716,674798,523883,515255,991653,632409,439597,745960,125093,218573,1012929,586004,24490,262549,881304,982996,816293,185889,933321,929592,208475,320888,326459,418146,175454,454449,565052,542022,85591,503245,131159,214186,928797,461724,655240,304128,808362,681234,929388,43177,254379,370222,10876,187296,853736,497507,677892,940835,25426,627846,570057,340414) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000942s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 473219 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 473219 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000435s ]