SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 446223 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 446223 [ RunTime:0.002173s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (420210,442117,274834,224403,200565,332872,780988,409350,1012767,259985,1043006,227622,1021286,284642,450740,659921,543252,122168,471099,412641,889877,775672,1016572,322136,118423,955295,889438,355751,1011545,684719,952259,665676,400768,832930,792079,209438,1041433,70380,738911,168763,885239,429775,360403,89380,169881,567871,661731,225469,790347,217804,140861,46217,42977,311417,736657,76156,422108,595362,444109,53282) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 446223 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 446223 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000452s ]