SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001374s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020483 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020483 [ RunTime:0.002649s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (156174,686466,473339,128984,495805,546857,860527,165944,632187,285755,459040,583353,680927,156597,34994,638021,42611,296916,368028,933192,703789,941961,687248,433116,135913,504838,702175,3297,311024,901876,479433,589835,145471,744911,452181,585992,758879,711876,998187,385427,1031049,1029264,780580,765687,866059,453544,328520,953641,242678,409746,595497,236294,241683,472891,644972,789838,271222,846704,164034,440710) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001572s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020483 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020483 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001162s ]