SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503448 LIMIT 1 [ RunTime:0.001809s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503448 [ RunTime:0.005193s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (104471,114754,582969,631904,478306,676096,211103,397130,136266,119709,451368,855317,843546,410914,163961,966722,811592,485294,6315,226654,9211,757693,748000,80914,767575,792042,438516,975394,668223,1016050,694367,885053,315859,138934,796982,443969,103366,589959,51871,115988,158723,290327,654755,38039,134923,804065,494253,447912,974538,337211,353015,584709,564163,211459,306146,139632,307043,376239,902821,561886) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503448 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503448 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000466s ]