SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 343891 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 343891 [ RunTime:0.002082s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (236817,32936,374910,783785,72164,233837,891426,759879,175679,291569,309041,447583,199633,299128,304748,826333,597786,252710,539448,661149,402283,666760,709391,369625,882727,760309,99732,491274,799567,182793,433587,453611,840522,243950,294694,413215,692401,596741,611064,24076,531884,9109,686320,74291,530556,268678,420548,470292,258377,855327,412387,386777,658605,628693,402985,270770,94180,333620,51307,684916) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 343891 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000494s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 343891 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]