SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 300813 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 300813 [ RunTime:0.002563s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (181795,748967,345560,734787,381168,174561,653243,278007,1040646,185835,778123,888914,441933,4191,574547,401028,12135,825697,801133,995752,796727,240525,122017,869130,88288,624844,607611,662926,427479,435360,842455,304270,281014,458542,155784,165704,552915,74748,137801,994976,191824,934196,302846,999023,618839,493765,152476,359425,242341,553688,474595,1036696,736148,590780,457023,934127,804919,206261,686365,147480) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002797s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 300813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 300813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000483s ]