SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 345571 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 345571 [ RunTime:0.001980s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (594798,298163,617564,454900,243149,421042,267397,984511,171619,852122,330727,582814,401581,1021049,792700,372493,213122,904885,798210,117219,307449,263040,156331,756263,897662,429507,917409,529475,84329,511055,612240,779832,478666,98211,651893,825073,231189,255790,746128,245836,188010,874187,936942,317238,515374,719257,226069,881633,430542,462598,773534,643953,746159,682571,39218,735176,707087,414915,13105,288554) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 345571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 345571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]