SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 193503 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 193503 [ RunTime:0.001973s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (944246,151272,849826,238129,558636,819164,71330,774710,250523,74060,394673,822835,499689,477219,915978,236910,147615,900406,611454,761439,34481,422474,911277,232744,495840,804386,649544,11132,70098,966297,340657,401929,1014746,884938,741761,874877,203667,191258,518785,617972,141669,755797,532788,576964,647069,828273,278136,774463,18204,226916,203987,686464,286675,1023220,100661,143776,135755,905006,827450,848804) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000991s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 193503 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 193503 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]