SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 496072 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 496072 [ RunTime:0.002639s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (768314,37598,162610,798363,832794,449795,198891,166866,1000739,649400,431366,358037,920468,404431,148817,243821,658627,982221,801449,507052,758779,721883,966801,832640,675974,367377,371424,159780,402661,884134,166543,462864,762294,379362,589725,647173,457221,289519,516428,553633,832503,754426,297321,498238,557627,31277,996348,393113,132499,402795,952518,181327,689342,796039,170394,126975,722658,1005080,94306,463235) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 496072 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 496072 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]