SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 488478 LIMIT 1 [ RunTime:0.000532s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 488478 [ RunTime:0.001003s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (345657,334025,915365,762573,395013,1000063,707594,723450,404927,222957,79838,751544,274352,675840,18762,234310,769110,300214,498888,386542,384695,670106,181413,464879,654814,126876,29911,945646,610764,211793,388920,552487,903530,543741,700638,879563,52672,312959,1019953,1000898,880678,629913,100714,834194,435804,600277,198986,800004,664613,849887,493826,309280,672462,318599,304137,501981,1026258,1035494,787859,943589) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 488478 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 488478 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]