SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10913 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10913 [ RunTime:0.001873s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (405265,697375,49126,776733,391813,679919,1040551,412933,473195,595765,329394,641837,543572,55938,563352,486435,593196,523527,42757,970248,689021,935540,318830,303302,886809,541804,848411,874163,389141,100555,375725,629208,513683,921662,371211,415255,803822,167361,1001627,692274,377778,839828,990966,490332,472072,674567,289744,562212,823087,50333,688313,62065,2597,899825,627135,336455,441582,557199,548845,868008) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10913 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10913 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]