SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 671990 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 671990 [ RunTime:0.001961s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (888649,459585,966428,986589,422463,969164,74122,541122,849218,456299,111038,971252,339521,310389,404871,174318,45215,538358,937251,204283,951649,64381,113493,497520,185191,351153,522624,315024,649657,982941,504459,359370,294238,488139,607029,681639,43693,88691,450544,814386,150524,661897,911265,560633,496674,356590,427071,889698,200696,788041,489373,940483,140792,326270,618380,716606,550136,156396,841561,503606) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 671990 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 671990 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]