SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1013176 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1013176 [ RunTime:0.002237s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (674460,487818,545639,375924,494331,234010,318049,166829,736716,272475,279035,584663,36463,647051,397934,158145,6245,543913,949667,575764,277997,377874,938362,941748,469425,109283,723722,953732,730956,424325,311753,638956,580943,647153,44524,386214,744596,850491,408887,857478,114990,122725,766412,498983,850469,846,275060,852409,404092,322248,116485,955397,719283,937870,280738,830514,865710,546384,771378,289737) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000960s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1013176 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1013176 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]