SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503943 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503943 [ RunTime:0.001530s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (570575,67533,499705,1006202,1020511,258826,916660,406388,238058,1010674,24514,549930,767185,284618,9754,724463,1080,1036343,493589,322024,36005,552914,512458,573253,978309,530921,862195,159418,680820,267884,169314,364187,291267,1015723,250274,841388,691104,199110,1045238,871454,796251,845876,659238,1011781,123936,1023601,348354,33915,975513,98989,976362,970178,123743,402606,482441,19523,860714,498992,109349,473875) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503943 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503943 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000489s ]