SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 523313 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 523313 [ RunTime:0.001933s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (31572,918096,971345,765492,411424,13304,351788,786047,884612,527592,799513,806886,458954,1046790,283360,495698,567569,918591,503346,127522,603053,931502,809761,768358,926165,935582,610041,1046424,123077,438349,619658,108658,356690,727793,996183,505833,413315,51570,838538,132854,354334,812594,213657,675841,470590,502082,535976,559766,638135,208785,348049,501519,536546,976789,951700,840432,956643,278014,537593,440582) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 523313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 523313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]