SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195468 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195468 [ RunTime:0.002741s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (294438,1045462,382464,993989,93238,995521,787895,392900,28180,991999,22641,544001,503138,924662,962237,373232,98862,965922,913038,679578,917766,615909,881900,448810,77321,577414,1046312,1003856,536970,407032,659549,128925,776133,206108,360996,823472,46971,172376,633518,341173,812476,631174,170907,169552,558663,526072,1033963,637400,864484,598943,168302,493175,775585,363902,729161,622268,943157,963549,192755,972981) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004855s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195468 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000567s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195468 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001232s ]