SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505520 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505520 [ RunTime:0.002197s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (917869,556494,599594,80146,448189,458939,385482,716312,119623,273670,865134,849615,853964,13164,368071,273865,272429,763348,855949,333303,823857,451436,940516,401631,348126,356058,592839,116063,553860,973763,472861,918195,138435,33142,2657,997028,666762,466104,538197,445369,865039,741074,988644,589478,676857,466331,530873,528649,557570,191538,76760,592947,314433,403717,978194,862671,823483,457994,90380,800934) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505520 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001317s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505520 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]