SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 142412 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 142412 [ RunTime:0.003610s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (37620,1035328,481073,820299,345228,368066,713786,379997,868139,254992,1126,45051,362696,691239,1033727,273778,625810,515855,717607,493260,420599,840625,68384,214251,205416,335672,623519,14131,319906,819749,239330,560028,286310,809215,123740,660508,537883,823122,84813,968281,965865,354279,839224,274000,1044456,804244,569421,552162,740232,208734,1025717,43004,659839,527437,694511,725070,670941,375985,582120,743525) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 142412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 142412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]