SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001604s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 426581 LIMIT 1 [ RunTime:0.000499s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 426581 [ RunTime:0.002197s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (888007,776956,771623,129135,66321,608884,524921,168140,409145,66415,707940,862029,47161,391144,67200,233811,299852,971405,382,241512,34261,58349,435179,779580,936777,858376,654860,21329,47076,749224,441010,434408,815239,588715,481325,871776,884676,324974,387444,488621,159038,1036584,823778,402061,233088,299734,601521,290745,119953,51255,239913,166637,38588,934049,563519,687198,77066,684871,773628,893988) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 426581 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000575s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 426581 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000713s ]