SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001354s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029010 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029010 [ RunTime:0.003635s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (151866,768779,700319,379310,209105,182604,993781,934260,52363,885606,420126,159970,700254,511288,36100,727685,1004091,879583,397264,467571,596013,971948,963055,979472,157185,713598,470526,889824,704509,1019982,451946,804790,571654,300619,207039,715177,796671,966065,911596,379693,951332,889785,677243,660836,508850,200049,303833,209315,424578,88590,371894,358877,261563,150663,1021332,838320,752819,1837,322492,621466) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001482s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001515s ]