SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029389 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029389 [ RunTime:0.001611s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (126077,352409,221067,752230,81537,6470,738466,901949,909216,686816,305960,860667,80835,647842,401757,775575,876506,274639,437583,298850,665955,773680,369022,54222,1008363,604248,596026,609872,188648,899619,475224,330720,631454,587916,264148,890613,609909,521966,53211,841347,394685,13762,669650,1000946,542809,769263,909068,637829,284747,525978,402514,485739,218399,912220,131693,1021492,236547,348367,638533,602151) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029389 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029389 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003705s ]