SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1044892 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1044892 [ RunTime:0.001520s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (598213,86600,648194,170259,411031,129241,304273,635116,114664,1044223,668728,219993,1016884,70192,297655,871476,759359,788474,933178,490495,203918,344319,511600,998880,157604,112654,406649,863517,287762,2851,1034320,641955,347088,345063,673773,1048147,43083,971578,173317,50969,633212,131596,260978,196,163896,397943,855924,788912,412594,586522,604297,1021920,19655,318090,989455,974019,433658,967674,70494,376020) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004126s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1044892 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1044892 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001672s ]