SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003449s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022531 LIMIT 1 [ RunTime:0.000783s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022531 [ RunTime:0.004933s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (927899,456721,430804,1024267,235864,366255,951337,850283,231409,1016790,18399,161794,167548,273720,196485,515943,664303,764628,561565,160077,585127,721587,1003205,896907,79559,541985,215792,457796,254722,685009,662680,957609,203114,25748,814111,265371,270101,311169,513178,70280,911198,767089,737471,896845,175725,606751,871811,830435,805043,688091,87425,478420,873544,432321,284553,336783,405084,292178,627539,755805) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.018061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022531 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022531 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000867s ]