SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 354351 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 354351 [ RunTime:0.001744s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (356191,923866,467747,383531,376097,794058,146891,904013,535276,236549,107711,984093,131766,948125,225143,490036,34375,533262,262634,77096,541852,245696,505035,70432,49134,484098,51844,577029,788428,179650,859064,796574,551266,421211,937902,312804,495009,599517,652286,888178,595266,888158,47199,411017,541358,1040405,286445,57390,164230,750162,652450,186113,991532,631003,721338,243815,942183,454397,368192,575790) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 354351 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 354351 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]