SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505318 LIMIT 1 [ RunTime:0.000493s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505318 [ RunTime:0.004507s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (281231,571716,841841,40758,219202,1021477,565394,498345,635026,1013522,956362,358916,733052,203259,812350,17950,63010,724514,825593,300322,57387,149211,743732,946202,855369,111940,701747,90484,215799,843264,245164,1032034,966904,460318,754298,598347,166622,1024591,374547,820488,774130,586623,845683,773908,56925,719328,127649,291071,663164,842041,279530,100055,47582,411372,373767,832579,560206,703167,881203,352190) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001792s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505318 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002140s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505318 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000347s ]