SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 422479 LIMIT 1 [ RunTime:0.000456s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 422479 [ RunTime:0.002489s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (800138,52420,439128,186736,862361,813798,507747,3759,585541,24335,587748,264981,363437,366824,317480,815833,629481,154831,497029,72352,404530,309084,1007018,817729,829676,126945,178783,448591,94024,344980,266269,512317,19063,194065,100308,870574,2558,333619,35566,5573,464159,336764,786538,291116,438386,624418,59875,616789,1035913,970695,911488,200736,898569,1026652,445283,850358,1016799,56240,541666,368619) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001906s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 422479 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 422479 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000393s ]