SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517518 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517518 [ RunTime:0.004175s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (287553,453812,885142,203950,969809,308738,327039,267049,360062,558462,217210,449572,664850,24051,652282,621669,1029442,289370,1000046,763708,828638,695620,283701,1042133,105420,292576,712695,891378,854346,380774,919551,296464,721049,452396,295567,985530,1000539,613542,307932,317915,590896,298378,874093,848038,892226,580949,641416,320228,927645,776138,339213,892984,774486,39270,208534,382083,859901,258546,119766,342345) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000981s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000468s ]