SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001338s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429750 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429750 [ RunTime:0.001394s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (470802,565458,737452,319526,301102,335072,327797,209713,174983,756932,14542,150602,1042808,284072,200177,134164,105432,250352,596919,336657,113319,509316,381367,729427,141879,736140,947645,1024185,829545,873129,650427,1025656,827752,76185,323298,348620,276171,53010,1036617,252215,968304,933101,656761,769400,360966,896038,196251,716988,383907,1013676,160404,303737,896774,935702,139388,819388,164947,670550,61178,501090) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000987s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429750 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429750 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]