SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506499 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506499 [ RunTime:0.002531s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (483472,333295,417102,153165,584337,1037020,218679,781408,195843,998046,552390,697000,636803,927209,714938,879205,363607,484011,451788,991647,1042705,57238,372235,412492,728616,770961,850504,47565,51680,904162,550561,22709,428060,987794,156213,124063,665471,819092,1035322,777095,1017926,171204,251500,718927,410405,1014562,986750,395238,508697,161042,524837,612862,345335,218171,688273,672826,8652,210091,984528,759372) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002586s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506499 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506499 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002108s ]