SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410391 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410391 [ RunTime:0.001786s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1037163,285855,79466,953057,958136,640551,744085,509311,447884,371758,1799,397035,250136,992499,995797,626344,635721,790435,1003619,237950,349579,337146,394397,985416,733124,411212,945662,379430,707048,372157,111913,381309,370730,748906,294354,143890,635632,740966,712825,572104,266214,364069,659891,387664,90351,811692,310492,811584,761654,791287,344679,69588,736685,159380,242288,618391,1048895,970763,430747,451773) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410391 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410391 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]