SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 315506 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 315506 [ RunTime:0.001837s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (931481,101733,693508,238276,1024673,697843,235989,894810,843930,1033749,429670,217688,461681,355022,566645,235521,916410,696166,167357,781825,295426,355115,166786,318724,978645,826035,1029843,707165,108956,905759,151688,323132,559050,869123,795765,260225,775486,122695,457282,342638,358174,374793,837122,947981,952130,961749,896457,465159,410831,83388,468760,158774,462819,815575,303583,307654,272296,190185,866155,445431) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 315506 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 315506 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000520s ]