SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 190310 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 190310 [ RunTime:0.001788s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (31641,775625,175980,836168,488274,368374,839795,747525,181153,707075,792451,1005390,434485,666358,290372,1038654,903485,604290,369685,701380,1021700,12027,356271,107658,250016,731554,703167,81705,549062,227772,51530,893625,91791,17333,897143,509830,286846,244980,444293,486088,820321,846389,102879,330545,389341,417695,1011321,975221,605088,838076,1028472,1031427,768509,613764,690689,980604,368033,793544,522468,141630) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 190310 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 190310 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]