SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503593 LIMIT 1 [ RunTime:0.005747s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503593 [ RunTime:0.004160s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (57056,324765,243088,632425,220088,746866,307939,917610,329396,20851,58714,707960,894444,368544,295715,936805,92917,576528,874505,169238,378187,93524,733208,50849,149012,323825,108611,829057,570396,662538,1003014,1023513,274893,408554,341107,147426,977378,1037165,931353,785936,851236,188476,550901,296985,765122,292881,213655,361748,725279,473473,272023,465554,355467,472278,889757,645046,623489,909026,458204,811110) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004785s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503593 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000862s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503593 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001282s ]