SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 190483 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 190483 [ RunTime:0.001978s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (446215,694260,593336,113320,444202,177019,547822,619212,660889,286458,653720,807493,637129,765199,43104,203736,488073,472989,410680,853418,765413,333533,774147,539185,36355,247234,471118,779051,981040,429547,810616,691440,1048699,291435,923719,125633,620635,751759,620531,669675,470156,399120,992650,140873,156116,215192,418729,977879,605140,451642,477352,106338,712975,864676,539692,216769,731381,641078,524811,194499) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 190483 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000492s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 190483 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000749s ]