SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 135203 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 135203 [ RunTime:0.003883s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (248110,164632,546543,195596,784953,198832,671484,669204,813038,298065,801463,153026,984423,914951,1002646,912702,70046,300481,510569,261740,209239,542066,190188,890259,830297,702360,1033107,395542,28475,834336,266980,999,488510,893588,496087,736905,507425,692607,91760,219801,596339,296782,859141,395996,47506,314327,1006309,28893,169864,617852,603434,421639,955199,441280,635272,194440,700466,786195,332336,260791) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 135203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 135203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000449s ]