SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400100 LIMIT 1 [ RunTime:0.000466s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400100 [ RunTime:0.002015s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1030327,312455,461626,81124,164953,60321,1019029,54530,168490,428060,717973,153298,326176,1018358,613319,814538,950845,588608,155353,903569,56476,860364,667846,537398,388738,571364,256167,297050,734652,74373,17324,891762,581848,689223,828184,476494,877404,637597,751821,1001547,471940,749073,552982,642532,900760,26935,980345,136933,928949,734903,743394,243720,284624,894504,424961,115217,547097,907371,280382,1006168) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400100 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400100 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000706s ]