SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 43988 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 43988 [ RunTime:0.001820s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (135063,1005548,1024329,304652,743949,714575,318847,857352,1042959,21643,699303,1739,539977,15576,68751,1005618,648996,433134,479677,379335,899015,990354,507079,606330,307358,560557,557625,39142,635415,471236,19709,275039,845896,507015,649728,982941,162225,741649,493626,793343,731850,956267,750052,810066,632059,803479,185522,547457,772152,917211,555644,445730,747620,742673,808228,502151,854946,404873,510516,603557) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002189s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 43988 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 43988 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001231s ]