SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201426 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201426 [ RunTime:0.001803s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (250911,258208,111754,167390,677664,970306,57090,655548,528820,128134,312331,13272,174432,737341,726191,140190,276671,497298,963866,962824,445748,322752,816366,300163,814751,348897,541797,112724,198456,333575,878871,686098,1013841,854161,424761,997215,769991,655618,370285,747784,414720,310570,496239,845009,414635,439412,900751,375806,788114,433671,178128,275713,375212,728289,958457,291949,485588,103457,484636,535073) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001810s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201426 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201426 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]