SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001576s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037440 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037440 [ RunTime:0.001147s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (189592,648115,449458,685701,140632,486311,667333,25099,64485,121639,697056,948861,986248,913215,466950,363677,761841,641985,646351,781542,668702,1015143,1040304,232284,213546,101409,288990,826130,381280,182919,586189,661228,439629,403409,159915,704762,692203,756332,616641,1033176,644793,972566,426121,613735,447497,97633,583660,473382,23829,402428,732603,200237,192867,945059,611003,657329,548344,122739,710836,346603) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037440 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000576s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037440 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]