SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 30811 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 30811 [ RunTime:0.001812s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1045350,158737,159046,201844,427397,1034704,733774,148142,353066,440851,133277,57138,418250,173707,888718,571410,987202,672163,820227,775926,317429,606294,273884,256658,194759,404187,438725,905808,449171,748667,783573,228094,327641,90286,866419,242976,989070,554771,410937,492840,27242,79711,938173,924547,990998,372352,301019,557350,809142,567240,296966,166284,209747,551369,579960,448211,434536,80810,298700,505898) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000926s ]