SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 293976 LIMIT 1 [ RunTime:0.000288s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 293976 [ RunTime:0.001941s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (804491,913103,312970,984982,471748,801289,807628,1022072,759042,1015121,498700,755891,372508,202856,853790,63242,440215,768470,773004,751131,257781,336297,321884,1005596,580150,1035439,424104,564492,627851,641837,527063,789296,818954,192893,286358,935973,712908,674536,473576,464291,380090,701436,639382,321155,992090,502748,905157,140433,294839,46,102628,813509,942648,991586,541257,579205,692970,10049,385434,375144) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 293976 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001683s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 293976 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000638s ]