SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001484s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 807880 LIMIT 1 [ RunTime:0.000463s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 807880 [ RunTime:0.004190s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1005204,649948,1028738,804025,277068,971925,665087,370061,657550,651050,69045,615781,744311,951164,577457,1015910,756700,494218,1037259,147164,20688,23948,441697,875460,20472,857650,45741,318288,418124,1005647,227892,578090,675262,209570,938038,336862,468779,360108,408366,802426,583795,646904,993838,41003,604008,798121,441671,733951,620084,74648,184338,560700,82742,547739,798115,603988,487159,171420,114685,387332) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 807880 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 807880 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000601s ]