SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428845 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428845 [ RunTime:0.002083s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (400104,409354,333453,47072,396553,484208,815503,421966,458603,267231,853899,704142,958985,878646,114567,598944,740598,538165,248462,867491,333679,509810,700998,725411,810271,368082,915071,304560,108814,641390,793326,999186,752627,34867,518629,1009860,727166,49290,980172,856786,905469,183485,277344,340854,786498,360519,173933,711168,662775,850802,167269,936958,734933,385440,673681,124487,1037329,819114,735718,1034087) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428845 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428845 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000465s ]