SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504299 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504299 [ RunTime:0.001827s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (931018,179200,761382,205758,18358,664251,364241,1041425,550488,535216,877075,445926,769998,940193,124757,451254,631377,510148,904768,894556,1032913,15054,144546,153801,735557,727395,577848,820396,101494,718712,528663,711087,417427,825990,883985,434547,148167,112376,764157,979829,791449,424041,386195,880645,166053,1014599,692162,970844,474948,632638,828767,551276,477303,410047,883685,45344,208731,993028,923074,230415) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504299 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504299 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000663s ]