SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 98106 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 98106 [ RunTime:0.001499s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (755562,929198,273468,849504,1029184,51650,603227,746863,977260,1034558,537762,70720,298226,831343,943336,221887,507585,309494,876758,681502,703104,145032,52473,700940,140634,871036,101466,462052,1029910,223452,965318,123121,795853,560908,933412,6845,531965,272156,78170,334880,536506,47031,989039,110156,138001,409181,409450,157438,654024,912965,100196,43694,466973,310276,158882,84798,239958,961301,789934,42697) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 98106 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 98106 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000483s ]