SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 442845 LIMIT 1 [ RunTime:0.000819s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 442845 [ RunTime:0.001661s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (485747,87680,1002388,896055,68838,832952,53739,617424,216708,354582,485425,621892,347776,1022534,639145,678590,224989,1687,971980,758941,444970,945118,15886,709149,977044,448923,938049,985006,334780,163069,59923,906550,432279,1025359,291000,562905,103029,1047777,69202,422789,539371,758867,452609,29896,154221,534721,608361,185639,1028168,317123,856622,857557,912263,920242,116185,444147,1027519,505121,1604,487499) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 442845 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000469s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 442845 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000680s ]