SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036663 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036663 [ RunTime:0.001953s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1004444,564766,151475,285015,538186,697273,63690,15638,828239,847517,1015270,993157,140785,607411,175492,732800,721322,368774,474824,42191,399683,72383,72333,734412,302853,584486,551271,472924,752991,649676,756022,819275,7179,693521,547161,562817,995081,132482,898863,89371,106313,1015559,111356,633939,699230,753875,931410,996043,468849,410626,874754,716459,1021776,847800,686975,321545,979165,106524,837461,239048) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036663 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036663 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000444s ]