SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510610 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510610 [ RunTime:0.002489s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (283661,929966,135411,280626,996895,334796,552181,901406,777370,252471,778121,36928,785644,170775,416184,614819,258702,338840,405545,218612,721331,973329,615950,833372,856218,350164,988898,1048314,320236,115565,862878,534007,19616,624170,967896,499316,763572,245117,71972,288026,348168,1007653,706811,613882,611833,908077,266646,658667,820674,547251,394312,1033638,614896,939573,287300,77555,278047,695319,39028,331093) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510610 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000523s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510610 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003624s ]