SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001356s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 484810 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 484810 [ RunTime:0.002279s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (207913,487364,244158,540165,429229,917646,933065,768282,334193,506890,526415,34145,663539,748742,854762,68066,701134,925795,280651,929181,759234,985094,938975,313661,626304,325606,1044114,971552,26735,747067,44000,460839,123929,740731,32107,979013,980391,312095,750681,943959,949,761986,349094,652308,110047,551347,308702,791323,986036,252735,85491,348815,988894,854666,266578,84412,378788,1014231,525986,98002) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000932s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 484810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 484810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]