SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 465058 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 465058 [ RunTime:0.001557s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (789991,822368,1001161,1007221,391771,864900,845295,242563,843265,331404,786438,10491,822560,292962,379253,667072,947200,856595,494352,176603,1000230,448763,891552,223033,182745,803186,370819,80689,730383,629203,311789,528627,187222,725928,588125,986688,753022,152741,1024224,427347,360436,204051,234649,168434,683280,793751,132426,913484,216960,273241,685115,1019055,886332,129601,812580,386335,837256,327439,139020,316484) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001053s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 465058 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 465058 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]