SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001687s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532289 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532289 [ RunTime:0.001678s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (681592,291017,731921,176170,429926,892344,229387,398255,202860,13837,200916,124728,478448,192907,771247,1044708,473425,289424,684439,892410,588026,516187,917397,551870,418748,798939,124263,337795,131286,15811,116192,10687,928890,544403,857169,787896,154419,612534,556478,502883,603202,664330,566703,97256,697981,279332,1048019,329148,1014781,30292,356416,62870,38325,997302,51400,823074,989038,631696,204071,60250) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000977s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532289 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532289 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000461s ]