SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002891s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1033104 LIMIT 1 [ RunTime:0.001976s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1033104 [ RunTime:0.003759s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (931186,757272,939470,224473,81440,131293,572631,903636,192153,812399,437316,326675,922478,240930,152731,485105,107119,545511,454394,99804,769774,399883,389716,624390,59455,47849,485721,899579,755444,222385,641859,922473,95364,640569,806339,792015,972915,344019,341885,705595,457069,160297,409222,402372,355634,310859,912071,422318,551461,130914,772015,968567,81394,1041288,757664,424859,553037,739750,460982,669420) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001849s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1033104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000568s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1033104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000428s ]