SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010980 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010980 [ RunTime:0.001657s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (873457,503496,764461,111195,535461,468774,605203,862759,628096,752726,730685,685478,416784,538190,334536,196392,756044,724893,971043,122337,104879,456125,183653,211899,837746,30968,707868,489507,193796,171754,608439,602109,947597,642436,330370,704328,773063,536654,1004059,254895,775988,854001,916667,567213,670571,674531,462748,8940,413058,831165,186366,77776,520883,789445,426082,217968,968002,789322,634953,949677) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010980 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010980 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]