SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001375s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475411 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475411 [ RunTime:0.001680s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (26373,117344,299515,473887,951415,460118,467449,1015686,495685,211953,1015274,50722,829733,466704,948184,114347,555530,493909,325965,892639,207142,365539,743424,634466,482170,697203,284579,508434,180465,865153,613999,270131,723534,153995,110779,2698,14281,1032033,907769,785634,602300,95812,507785,974151,547351,632152,449987,342048,293121,537319,368846,329717,103808,925496,553611,901363,576530,33788,273991,962835) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001512s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475411 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475411 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]