SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001359s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522284 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522284 [ RunTime:0.002451s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (837375,37733,57000,33984,173241,912477,95062,192394,640889,547965,171021,759782,525885,779095,258337,836760,123733,562031,750182,71707,238799,250679,778589,152531,455182,918668,490443,245977,95736,216432,585005,800744,264595,695027,865456,611023,791511,715770,19773,82318,549345,660994,951239,394261,533031,526582,484452,520366,1038039,223769,813738,205049,230692,921469,490605,658553,608026,550648,165749,103010) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003274s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522284 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522284 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001212s ]