SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 473480 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 473480 [ RunTime:0.001686s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (634724,669906,907379,102857,575366,495525,1048074,547678,63453,906060,762764,511137,738508,788137,160827,958798,54785,869666,339218,204120,21312,370771,124832,538395,520054,490575,325662,178342,1003651,585136,870126,890250,828614,285730,427069,770581,195284,544438,248816,807032,1036722,886630,1040520,305694,107141,626757,366929,494071,926309,165246,551749,511899,683926,759151,961654,460610,480613,535231,145251,355766) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000964s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 473480 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 473480 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000435s ]