SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001372s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 500210 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 500210 [ RunTime:0.003040s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (516925,159852,915735,299723,237414,153143,474537,203443,787478,292228,238274,17895,791621,1003812,127473,511742,181293,498391,980243,151156,618043,481661,512774,1441,440883,83070,353558,382379,306438,346564,216320,14228,599055,332487,797238,86227,430734,680602,706966,928041,1044707,497132,187430,166135,853260,171079,326648,836810,379596,984447,847676,993523,906027,55199,478957,277444,1017944,505085,280551,617650) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 500210 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000497s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 500210 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]