SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001811s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 447195 LIMIT 1 [ RunTime:0.000764s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 447195 [ RunTime:0.002176s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (335208,335970,187736,433681,343928,37560,816903,546778,669256,667861,233654,857089,743164,1048458,378134,186214,207642,1004398,681986,52060,847462,728600,654133,463737,257036,325583,904817,1035179,840309,480663,675262,798450,1044943,454728,614070,387626,496851,824660,341521,891398,379374,855720,597174,947571,197587,95305,998749,430444,834232,884033,755605,517854,219734,691903,703745,859378,284052,812861,718759,391834) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000984s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 447195 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 447195 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]