SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 453051 LIMIT 1 [ RunTime:0.002484s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 453051 [ RunTime:0.005653s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (266339,900843,568208,77346,280478,941969,19503,203881,788268,14410,981538,638054,535953,385098,606587,206746,552075,346530,241259,435417,561610,277456,974914,618630,520147,376983,5436,490614,408659,329014,379752,183716,132885,809324,319234,569256,727892,600245,719500,430808,66748,60650,283305,511994,149219,347324,473982,480831,156685,597079,82202,1033099,735110,110094,409336,678618,543308,55341,803157,246674) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003509s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 453051 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 453051 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]