SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104888 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104888 [ RunTime:0.001541s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1005064,249642,313752,30102,463111,642613,510218,71868,709222,352935,769171,351539,135455,520167,444361,121803,362853,380267,359903,961086,930735,54806,238434,1028433,685487,862112,172003,272988,618246,1006207,74266,585233,752660,1026434,988837,914404,88922,885982,619603,755680,365750,110612,386718,357793,638352,329950,552554,975132,624909,203815,160149,396242,211365,379710,724313,261621,276626,405340,318722,427027) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104888 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104888 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000867s ]