SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 209280 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 209280 [ RunTime:0.002021s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (201307,800724,607557,416602,334471,182692,99412,672715,121323,290406,284974,873233,395471,778369,110105,319083,464658,124412,590938,86509,342966,774106,1009449,950432,785992,809835,1016320,977551,33135,947926,779604,608422,177697,759485,345248,712608,216574,210362,488276,430987,179277,635272,490211,119268,715130,902463,653053,54235,808613,306011,25191,615491,8006,955409,359802,553451,792363,766347,733524,751956) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 209280 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 209280 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000425s ]